409
How can I display a different caption in the label area

With AxComboBox1
	.BeginUpdate()
	.Style = EXCOMBOBOXLib.StyleEnum.DropDownList
	.IntegralHeight = True
	.HeaderVisible = False
	.SingleEdit = True
	.SearchColumnIndex = -1
	.AdjustSearchColumn = False
	.Columns.Add("Language").Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
	With .Items
		.AddItem("English")
		.AddItem("Hebrew")
		.AddItem("Spanish")
	End With
	.LabelText = " <b>custom</b> text "
	.EndUpdate()
End With
160
How can I display a custom size picture to a cell or item

With AxComboBox1
	.DefaultItemHeight = 48
	.Columns.Add("C1")
	With .Items
		.CellPicture(.AddItem("Text"),0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
	End With
End With
210
How can I display a computed column and highlight some values that are negative or less than a value

Dim var_ConditionalFormat
With AxComboBox1
	.Columns.Add("A")
	.Columns.Add("B")
	.Columns.Add("(A+B)*1.19").ComputedField = "(%0 + %1) * 1.19"
	With .Items
		.CellCaption(.AddItem(1),1) = 2
	End With
	With .Items
		.CellCaption(.AddItem(10),1) = 20
	End With
	var_ConditionalFormat = .ConditionalFormats.Add("%2 > 10")
	With var_ConditionalFormat
		.Bold = True
		.ForeColor = RGB(255,0,0)
		.ApplyTo = &H2
	End With
End With
276
How can I display a button inside the item or cell

Dim h
With AxComboBox1
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = " Button 1 "
		.CellHAlignment(h,1) = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
		.CellHasButton(h,1) = True
		h = .AddItem("Cell 2")
		.CellCaption(h,1) = " Button 2 "
		.CellHAlignment(h,1) = EXCOMBOBOXLib.AlignmentEnum.CenterAlignment
		.CellHasButton(h,1) = True
	End With
End With
203
How can I customize the items being displayed in the drop down filter window

With AxComboBox1
	With .Columns.Add("Custom Filter")
		.DisplayFilterButton = True
		.DisplayFilterPattern = False
		.CustomFilter = "Excel Spreadsheets (*.xls )||*.xls|||Word Documents||*.doc|||Powerpoint Presentations||*.pps|||Text Documents (*.log,*.txt)||*." & _
	"txt|*.log"
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exPattern
		.Filter = "*.xls"
	End With
	.Items.AddItem("excel.xls")
	.Items.AddItem("word.doc")
	.Items.AddItem("pp.pps")
	.Items.AddItem("text.txt")
	.ApplyFilter()
End With
549
How can I create a new ADO recordset

Dim rs
With AxComboBox1
	.BeginUpdate()
	rs = CreateObject("ADODB.Recordset")
	With rs
		.Fields.Append("A",8)
		.Fields.Append("B",8)
		.Open()
		.AddNew()
		.Fields.Item("A").Value = "Item A.1"
		.Fields.Item("B").Value = "Item B.1"
		.Update()
		.AddNew()
		.Fields.Item("A").Value = "Item A.2"
		.Fields.Item("B").Value = "Item B.2"
		.Update()
	End With
	.DataSource = rs
	.Value = "Item A.1"
	.EndUpdate()
End With
372
How can I convert the expression to a string so I can look into the date string expression for month's name

With AxComboBox1
	.Columns.Add("Number")
	.Columns.Add("Str").ComputedField = "str(%0) + ' AA'"
	With .Items
		.AddItem("-1.98")
		.AddItem("0.99")
		.AddItem("1.23")
		.AddItem("2.34")
	End With
End With
427
How can I collapse all items

Dim h
With AxComboBox1
	.BeginUpdate()
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	.Columns.Add("Items")
	With .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Nothing,"Child 1")
		.InsertItem(h,Nothing,"Child 2")
		h = .AddItem("Root 2")
		.InsertItem(h,Nothing,"Child 1")
		.InsertItem(h,Nothing,"Child 2")
		.ExpandItem(0) = False
	End With
	.EndUpdate()
End With
340
How can I close the drop down window when user double clicks it

Dim h
With AxComboBox1
	.CloseOnDblClk = True
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
	.TreeColumnIndex = 1
	.Columns.Add("Column 1")
	.Columns.Add("Column 2")
	With .Items
		h = .AddItem("Root 1.1")
		.CellCaption(h,1) = "Root 1.2"
		.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
		.CellCaption(.InsertItem(h,Nothing,"Child 2.1"),1) = "Child 2.2"
		.ExpandItem(h) = True
		h = .AddItem("Root 2.1")
		.CellCaption(h,1) = "Root 2.2"
		.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
	End With
End With
384
How can I check the hour part only so I know it was afternoon

With AxComboBox1
	.ConditionalFormats.Add("hour(%0)>=12").Bold = True
	.Columns.Add("Date")
	.Columns.Add("Hour").ComputedField = "hour(%0)"
	With .Items
		.AddItem(#1/11/2001 10:00:00 AM#)
		.AddItem(#2/22/2002 11:00:00 AM#)
		.AddItem(#3/13/2003 0:00:00 PM#)
		.AddItem(#4/14/2004 1:00:00 PM#)
	End With
End With
4
How can I change/rename the column's name

With AxComboBox1
	.Columns.Add("ColumnName").Caption = "NewName"
End With
134
How can I change the width of the columns being displayed in the sort bar

With AxComboBox1
	.SortBarVisible = True
	.SortBarColumnWidth = 48
	.Columns.Add("C1").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortAscending
	.Columns.Add("C2").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortDescending
End With
510
How can I change the visual appearance of the filter bar's close button (solid)

With AxComboBox1
	.BeginUpdate()
	.Columns.Add("Item").DisplayFilterButton = True
	With .Columns.Add("Pos")
		.AllowSizing = False
		.AllowSort = False
		.Width = 32
		.FormatColumn = "1 apos ``"
		.Position = 0
	End With
	With .Items
		.AddItem("Item A")
		.AddItem("Item B")
		.AddItem("Item C")
	End With
	.FilterBarPromptVisible = EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible
	.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exFooterFilterBarButton,255)
	.EndUpdate()
End With
511
How can I change the visual appearance of the filter bar's close button (EBN)

With AxComboBox1
	.BeginUpdate()
	With .VisualAppearance
		.Add(1,"gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJ" & _
	"jyI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKm" & _
	"SZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8OR" & _
	"OicbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2" & _
	"DYxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJX" & _
	"AiAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaK" & _
	"JDCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G" & _
	"0TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEA" & _
	"kjIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRS" & _
	"MRsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhA" & _
	"QHkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ")
	End With
	.Columns.Add("Item").DisplayFilterButton = True
	With .Columns.Add("Pos")
		.AllowSizing = False
		.AllowSort = False
		.Width = 32
		.FormatColumn = "1 apos ``"
		.Position = 0
	End With
	With .Items
		.AddItem("Item A")
		.AddItem("Item B")
		.AddItem("Item C")
	End With
	.FilterBarPromptVisible = EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarToggle Or EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible
	.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exFooterFilterBarButton,16777216)
	.EndUpdate()
End With
131
How can I change the visual appearance of the control's sort bar, using EBN files

With AxComboBox1
	.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
	.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
	.SortBarVisible = True
	.GetOcx().BackColorSortBar = &H1000000
	.GetOcx().BackColorSortBarCaption = &H2000000
	.Appearance = EXCOMBOBOXLib.AppearanceEnum.None2
End With
499
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 3)

Dim h
With AxComboBox1
	.BeginUpdate()
	With .VisualAppearance
		.Add(3,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
	"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
	"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
	"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _
	"XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _
	"gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _
	"INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=")
		.Add(1,"CP:3 -2 -2 2 2")
		.Add(4,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
	"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
	"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
	"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _
	"eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _
	"FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _
	"JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=")
		.Add(2,"CP:4 -2 -2 2 2")
	End With
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
	.HasButtons = EXCOMBOBOXLib.ExpandButtonEnum.exCustom
	.set_HasButtonsCustom(False,16777216)
	.set_HasButtonsCustom(True,33554432)
	.Columns.Add("Column")
	With .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Nothing,"Child 1")
		.InsertItem(h,Nothing,"Child 2")
		.ExpandItem(h) = True
		h = .AddItem("Root 2")
		.InsertItem(h,Nothing,"Child")
	End With
	.EndUpdate()
End With
498
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 2)

Dim h
With AxComboBox1
	.BeginUpdate()
	With .VisualAppearance
		.Add(1,"XP:TREEVIEW 2 1")
		.Add(2,"XP:TREEVIEW 2 2")
	End With
	.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphOpen,16777216)
	.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphClose,33554432)
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	.Columns.Add("Column")
	With .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Nothing,"Child 1")
		.InsertItem(h,Nothing,"Child 2")
		.ExpandItem(h) = True
		h = .AddItem("Root 2")
		.InsertItem(h,Nothing,"Child")
	End With
	.EndUpdate()
End With
496
How can I change the visual appearance of the +/- buttons (method 1)

Dim h
With AxComboBox1
	.BeginUpdate()
	With .VisualAppearance
		.Add(1,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
	"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
	"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
	"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _
	"XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _
	"gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _
	"INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=")
		.Add(2,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
	"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
	"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
	"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _
	"eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _
	"FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _
	"JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=")
	End With
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphOpen,16777216)
	.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphClose,33554432)
	.Columns.Add("Column")
	With .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Nothing,"Child 1")
		.InsertItem(h,Nothing,"Child 2")
		.ExpandItem(h) = True
		h = .AddItem("Root 2")
		.InsertItem(h,Nothing,"Child")
	End With
	.EndUpdate()
End With
275
How can I change the state of a radio button

Dim h
With AxComboBox1
	.MarkSearchColumn = False
	.SelBackColor = RGB(255,255,128)
	.SelForeColor = RGB(0,0,0)
	.Columns.Add("C1")
	.Columns.Add("C2")
	.Columns.Add("C3")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Radio 1"
		.CellHasRadioButton(h,1) = True
		.CellRadioGroup(h,1) = 1234
		.CellCaption(h,2) = "Radio 2"
		.CellHasRadioButton(h,2) = True
		.CellRadioGroup(h,2) = 1234
		.CellState(h,1) = 1
	End With
End With
273
How can I change the state of a checkbox

Dim h
With AxComboBox1
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Check Box"
		.CellHasCheckBox(h,1) = True
		.CellState(h,1) = 1
	End With
End With
132
How can I change the sort bar's foreground color

With AxComboBox1
	.SortBarVisible = True
	.ForeColorSortBar = RGB(255,0,0)
End With
130
How can I change the sort bar's background color

With AxComboBox1
	.SortBarVisible = True
	.BackColorSortBar = RGB(255,0,0)
	.BackColorSortBarCaption = RGB(128,0,0)
End With
289
How can I change the size ( width, height ) of the picture

Dim h
With AxComboBox1
	.Columns.Add("Default")
	With .Items
		h = .AddItem("Root 1")
		.CellPicture(h,0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
		.CellPictureWidth(h,0) = 24
		.CellPictureHeight(h,0) = 24
		.ItemHeight(h) = 32
		h = .AddItem("Root 2")
		.CellPicture(h,0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
		.ItemHeight(h) = 48
	End With
End With
32
How can I change the position of the column

With AxComboBox1
	.Columns.Add("Column 1")
	.Columns.Add("Column 2").Position = 0
End With
298
How can I change the position of an item

With AxComboBox1
	.Columns.Add("Default")
	With .Items
		.AddItem("Item 1")
		.AddItem("Item 2")
		.ItemPosition(.AddItem("Item 3")) = 0
	End With
End With
202
How can I change the order or the position of the columns in the sort bar

With AxComboBox1
	.SortBarVisible = True
	.SortBarColumnWidth = 48
	.Columns.Add("C1").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortAscending
	.Columns.Add("C2").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortDescending
	.Columns.Item("C2").SortPosition = 0
End With
48
How can I change the name of the week days in the drop down calendar window, being displayed when I filter items between dates

With AxComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.DisplayFilterDate = True
	End With
	.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarDateWeekDays,"Du Lu Ma Mi Jo Vi Si")
	.ApplyFilter()
End With
47
How can I change the name of the months in the drop down calendar window, being displayed when I filter items between dates

With AxComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.DisplayFilterDate = True
	End With
	.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarDateMonths,"Janvier F vrier Mars Avril Mai Juin Juillet Ao t Septembre Octobre Novembre D cembre")
	.ApplyFilter()
End With
133
How can I change the height of the sort bar's

With AxComboBox1
	.SortBarVisible = True
	.SortBarHeight = 48
End With
252
How can I change the height for all items

With AxComboBox1
	.DefaultItemHeight = 32
	.Columns.Add("Column")
	.Items.AddItem("One")
	.Items.AddItem("Two")
End With
124
How can I change the header's background color, when multiple levels are displayed

With AxComboBox1
	.BackColorLevelHeader = RGB(250,0,0)
	.Columns.Add("S").Width = 32
	.Columns.Add("Level 1").LevelKey = 1
	.Columns.Add("Level 2").LevelKey = 1
	.Columns.Add("Level 3").LevelKey = 1
End With
344
How can I change the foreground color for edit controls

Dim h
With AxComboBox1
	.ForeColorEdit = RGB(255,0,0)
	.IntegralHeight = True
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
	.TreeColumnIndex = 1
	.Columns.Add("Column 1")
	.Columns.Add("Column 2")
	With .Items
		h = .AddItem("Root 1.1")
		.CellCaption(h,1) = "Root 1.2"
		.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
		.CellCaption(.InsertItem(h,Nothing,"Child 2.1"),1) = "Child 2.2"
		.ExpandItem(h) = True
		h = .AddItem("Root 2.1")
		.CellCaption(h,1) = "Root 2.2"
		.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
	End With
	.set_Select(0,"Root 1.1")
End With
215
How can I change the foreground color for all cells in the column

Dim var_ConditionalFormat
With AxComboBox1
	var_ConditionalFormat = .ConditionalFormats.Add("1")
	With var_ConditionalFormat
		.ForeColor = RGB(255,0,0)
		.ApplyTo = EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
	End With
	.Columns.Add("Column")
	.Items.AddItem(0)
	.Items.AddItem(1)
End With
424
How can I change the foreground color for a particular column

With AxComboBox1
	With .Columns
		.Add("Column 1")
		.Add("Column 2").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderForeColor) = 8439039
		.Add("Column 3")
	End With
End With
300
How can I change the font for entire item
Dim f
With AxComboBox1
	.Columns.Add("Default")
	.Items.AddItem("default font")
	f = CreateObject("StdFont")
	With f
		.Name = "Tahoma"
		.Size = 12
	End With
	With .Items
		.ItemFont(.AddItem("new font")) = f
	End With
End With
217
How can I change the font for all cells in the entire column

Dim f
With AxComboBox1
	f = CreateObject("StdFont")
	With f
		.Name = "Tahoma"
		.Size = 12
	End With
	With .ConditionalFormats.Add("1")
		.Font = f
		.ApplyTo = EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
	End With
	.Columns.Add("Column")
	.Items.AddItem(0)
	.Items.AddItem(1)
End With
302
How can I change the font for a cell

With AxComboBox1
	.Columns.Add("Default")
	.Items.AddItem("std font")
	With .Items
		.CellCaptionFormat(.AddItem("this <font tahoma;12>is a bit of text with</font> a different font"),0) = EXCOMBOBOXLib.CaptionFormatEnum.exHTML
	End With
End With
301
How can I change the font for a cell

Dim f
With AxComboBox1
	.Columns.Add("Default")
	.Items.AddItem("default font")
	f = CreateObject("StdFont")
	With f
		.Name = "Tahoma"
		.Size = 12
	End With
	With .Items
		.CellFont(.AddItem("new font"),0) = f
	End With
End With
129
How can I change the default caption being displayed in the control's sort bar

With AxComboBox1
	.SortBarVisible = True
	.SortBarCaption = "new caption"
End With
95
How can I change the control's font

With AxComboBox1
	.Font.Name = "Tahoma"
	.Columns.Add("Column")
End With
13
How can I change the column's width

With AxComboBox1
	.ColumnAutoResize = False
	.Columns.Add("Column 1").Width = 64
	.Columns.Add("Column 2").Width = 128
End With
455
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column

With AxComboBox1
	.BeginUpdate()
	.MarkSearchColumn = False
	With .ConditionalFormats.Add("1")
		.Bold = True
		.ForeColor = RGB(255,0,0)
		.ApplyTo = &H1
	End With
	.Columns.Add("C1")
	With .Columns.Add("C2")
		.HeaderBold = True
		.HTMLCaption = "<fgcolor=FF0000>C2"
	End With
	With .Items
		.CellCaption(.AddItem(10),1) = 11
		.CellCaption(.AddItem(12),1) = 13
	End With
	.EndUpdate()
End With
314
How can I change the color for separator / dividers items

Dim h
With AxComboBox1
	.MarkSearchColumn = False
	.TreeColumnIndex = -1
	.ScrollBySingleLine = False
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
		.CellSingleLine(h,1) = EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap
		h = .AddItem()
		.ItemDivider(h) = 0
		.ItemDividerLine(h) = EXCOMBOBOXLib.DividerLineEnum.DoubleDotLine
		.ItemDividerLineAlignment(h) = EXCOMBOBOXLib.DividerAlignmentEnum.DividerCenter
		.ItemHeight(h) = 6
		.SelectableItem(h) = False
		h = .AddItem("Cell 2")
		.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
		.CellSingleLine(h,1) = EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap
	End With
End With
359
How can I change the background color or the visual appearance using ebn for a particular column

With AxComboBox1
	.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
	With .Columns
		.Add("Column 1")
		.Add("Column 2").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor) = 16777216
		.Add("Column 3").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor) = 16777471
		.Add("Column 4")
	End With
End With
407
How can I change the background color for the filter field in the bottom part of the drop down portion

With AxComboBox1
	.BeginUpdate()
	.FilterForVisible = True
	.FilterForBackColor = RGB(240,240,240)
	.IntegralHeight = True
	.Columns.Add("Default")
	With .Items
		.AddItem("Item 1")
		.AddItem("Item 2")
		.AddItem("Item 3")
		.AddItem("Item 4")
		.AddItem("Item 5")
	End With
	.EndUpdate()
End With
343
How can I change the background color for edit controls

Dim h
With AxComboBox1
	.BackColorEdit = RGB(255,0,0)
	.IntegralHeight = True
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
	.TreeColumnIndex = 1
	.Columns.Add("Column 1")
	.Columns.Add("Column 2")
	With .Items
		h = .AddItem("Root 1.1")
		.CellCaption(h,1) = "Root 1.2"
		.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
		.CellCaption(.InsertItem(h,Nothing,"Child 2.1"),1) = "Child 2.2"
		.ExpandItem(h) = True
		h = .AddItem("Root 2.1")
		.CellCaption(h,1) = "Root 2.2"
		.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
	End With
	.set_Select(0,"Root 1.1")
End With
216
How can I change the background color for all cells in the column

Dim var_ConditionalFormat
With AxComboBox1
	var_ConditionalFormat = .ConditionalFormats.Add("1")
	With var_ConditionalFormat
		.BackColor = RGB(255,0,0)
		.ApplyTo = EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
	End With
	.Columns.Add("Column")
	.Items.AddItem(0)
	.Items.AddItem(1)
End With
358
How can I change the background color for a particular column

With AxComboBox1
	With .Columns
		.Add("Column 1")
		.Add("Column 2").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor) = 8439039
		.Add("Column 3")
	End With
End With
423
How can I change the background color for a particular column

With AxComboBox1
	With .Columns
		.Add("Column 1")
		.Add("Column 2").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor) = 8439039
		.Add("Column 3")
	End With
End With
408
How can I change the background appearance (ebn) for the filter field in the bottom part of the drop down portion

With AxComboBox1
	.BeginUpdate()
	.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
	.FilterForVisible = True
	.GetOcx().FilterForBackColor = &H1000000
	.IntegralHeight = True
	.Columns.Add("Default")
	With .Items
		.AddItem("Item 1")
		.AddItem("Item 2")
		.AddItem("Item 3")
		.AddItem("Item 4")
		.AddItem("Item 5")
	End With
	.EndUpdate()
End With
50
How can I change the "IsChecked/IsUnchecked" caption in the control's filter bar, when I filter for checked items

With AxComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exCheck
		.Filter = 0
	End With
	.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarIsChecked,"Check_On")
	.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarIsUnchecked,"Check_Off")
	.ApplyFilter()
End With
35
How can I change the "Filter For" caption in the column's drop down filter window

With AxComboBox1
	.Columns.Add("Column").DisplayFilterButton = True
	.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarFilterForCaption,"new caption")
End With
49
How can I change the "Checked" caption in the drop down filter window, when I filter for checked items

With AxComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exCheck
	End With
	.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarChecked,"with check on")
	.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarUnchecked,"with check off")
End With
231
How can I change at runtime the parent of the item

Dim hC,hP
With AxComboBox1
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	.Columns.Add("Default")
	With .Items
		hP = .AddItem("Root")
		hC = .AddItem("Child")
		.SetParent(hC,hP)
	End With
End With
57
How can I can I select programmatically "Blanks/NonBlanks" option in the column's drop down filter

With AxComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exBlanks
	End With
	.ApplyFilter()
End With
61
How can I can I programmatically filter the checked items

With AxComboBox1
	With .Columns.Add("Column")
		.Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
		.DisplayFilterButton = True
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exCheck
		.Filter = 0
	End With
	.Items.AddItem(0)
	With .Items
		.CellState(.AddItem(1),0) = 1
	End With
	.Items.AddItem(2)
	.ApplyFilter()
End With
62
How can I can I programmatically filter for items with a specified icon assigned

With AxComboBox1
	.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exImage
		.Filter = 1
	End With
	With .Items
		.CellImage(.AddItem("Image 1"),0) = 1
		.CellImage(.AddItem("Image 1"),0) = 1
		.CellImage(.AddItem("Image 2"),0) = 2
		.CellImage(.AddItem("Image 3"),0) = 3
	End With
	.ApplyFilter()
End With
60
How can I can I filter programmatically the items based on some numerichal rules

With AxComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exNumeric
		.Filter = "> 0 <= 1"
	End With
	.Items.AddItem(0)
	.Items.AddItem(1)
	.Items.AddItem(2)
	.ApplyFilter()
End With
59
How can I can I filter programmatically the items based on a range/interval of dates

With AxComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.DisplayFilterDate = True
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exDate
		.Filter = "1/1/2001 to 1/1/2002"
	End With
	.Items.AddItem("1/1/2001")
	.Items.AddItem("2/1/2002")
	.ApplyFilter()
End With
58
How can I can I filter programmatically given a specified pattern using wild characters like * or

With AxComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exPattern
		.Filter = "0*"
	End With
	.Items.AddItem(0)
	.Items.AddItem("00")
	.Items.AddItem(1)
	.Items.AddItem("11")
	.ApplyFilter()
End With
555
How can I build a "virtual" tree using your control

' BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
Private Sub AxComboBox1_BeforeExpandItem(ByVal sender As System.Object, ByVal e As AxEXCOMBOBOXLib._IComboBoxEvents_BeforeExpandItemEvent) Handles AxComboBox1.BeforeExpandItem
	With AxComboBox1
		With .Items
			.ItemHasChildren(.InsertItem(e.item,Nothing,"new")) = True
		End With
	End With
End Sub

With AxComboBox1
	.BeginUpdate()
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	.Style = EXCOMBOBOXLib.StyleEnum.DropDown
	.Columns.Add("Def")
	With .Items
		.AddItem("Item 1")
		.ItemHasChildren(.AddItem("Item 2")) = True
		.AddItem("Item 3")
	End With
	.Value = "Item 2"
	.EndUpdate()
End With
363
How can I bold the items that contains data or those who displays empty strings

Dim h,hC
With AxComboBox1
	.ConditionalFormats.Add("not len(%1)=0").Bold = True
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		h = .AddItem("Root")
		.InsertItem(h,Nothing,"Child 1")
		hC = .InsertItem(h,Nothing,"Child 2")
		.CellCaption(hC,1) = "1"
		.InsertItem(h,Nothing,"Child 3")
		.ExpandItem(h) = True
	End With
End With
211
How can I bold the entire column

Dim var_ConditionalFormat
With AxComboBox1
	var_ConditionalFormat = .ConditionalFormats.Add("1")
	With var_ConditionalFormat
		.Bold = True
		.ApplyTo = EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
	End With
	.Columns.Add("Column")
	.Items.AddItem(0)
	.Items.AddItem(1)
End With
25
How can I bold only a portion of the column's header

With AxComboBox1
	.Columns.Add("Column 1").HTMLCaption = "<b>Col</b>umn 1"
End With
269
How can I associate an extra data to a cell

Dim h
With AxComboBox1
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Cell 2"
		.CellData(h,1) = "your extra data"
	End With
End With
280
How can I assign multiple icons/pictures to a cell

Dim h
With AxComboBox1
	.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
	.Columns.Add("Default")
	With .Items
		h = .AddItem("Root <img>1</img> 1, <img>2</img>, ... and so on ")
		.CellCaptionFormat(h,0) = EXCOMBOBOXLib.CaptionFormatEnum.exHTML
	End With
End With
279
How can I assign multiple icons/pictures to a cell

Dim h
With AxComboBox1
	.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
	.Columns.Add("Default")
	With .Items
		h = .AddItem("Root 1")
		.CellImages(h,0) = "1,2,3"
	End With
End With
282
How can I assign multiple icon/picture to a cell

Dim h
With AxComboBox1
	.set_HTMLPicture("p1","c:\exontrol\images\zipdisk.gif")
	.set_HTMLPicture("p2","c:\exontrol\images\auction.gif")
	.Columns.Add("Default")
	With .Items
		h = .AddItem("text <img>p1</img> another picture <img>p2</img> and so on")
		.CellCaptionFormat(h,0) = EXCOMBOBOXLib.CaptionFormatEnum.exHTML
		.CellPicture(h,0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\colorize.gif`)")
		.ItemHeight(h) = 48
		.AddItem("Root 2")
	End With
End With
14
How can I assign checkboxes for the entire column

With AxComboBox1
	.Columns.Add("Column 1").Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
	.Items.AddItem(0)
	.Items.AddItem(1)
	.Items.AddItem(2)
End With
281
How can I assign an icon/picture to a cell

Dim h
With AxComboBox1
	.Columns.Add("Default")
	With .Items
		h = .AddItem("Root 1")
		.CellPicture(h,0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
		.ItemHeight(h) = 48
		.AddItem("Root 2")
	End With
End With
278
How can I assign an icon/picture to a cell

Dim h
With AxComboBox1
	.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
	.Columns.Add("Default")
	With .Items
		h = .AddItem("Root 1")
		.CellImage(h,0) = 1
		.CellImage(.InsertItem(h,Nothing,"Child 1"),0) = 2
		.CellImage(.InsertItem(h,Nothing,"Child 2"),0) = 3
		.ExpandItem(h) = True
	End With
End With
270
How can I assign a tooltip to a cell

Dim h
With AxComboBox1
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "tooltip"
		.CellToolTip(h,1) = "This is bit of text that's shown when the user hovers the cell"
	End With
End With
274
How can I assign a radio button to a cell

Dim h
With AxComboBox1
	.MarkSearchColumn = False
	.SelBackColor = RGB(255,255,128)
	.SelForeColor = RGB(0,0,0)
	.Columns.Add("C1")
	.Columns.Add("C2")
	.Columns.Add("C3")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Radio 1"
		.CellHasRadioButton(h,1) = True
		.CellRadioGroup(h,1) = 1234
		.CellCaption(h,2) = "Radio 2"
		.CellHasRadioButton(h,2) = True
		.CellRadioGroup(h,2) = 1234
		.CellState(h,1) = 1
	End With
End With
16
How can I assign a different background color for the entire column

With AxComboBox1
	.MarkSearchColumn = False
	.Columns.Add("Column 1").Def(EXCOMBOBOXLib.DefColumnEnum.exCellBackColor) = 255
	.Columns.Add("Column 2")
	.Items.AddItem(0)
	.Items.AddItem(1)
	.Items.AddItem(2)
End With
272
How can I assign a checkbox to a cell

Dim h
With AxComboBox1
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Check Box"
		.CellHasCheckBox(h,1) = True
	End With
End With
15
How can I assign a check box for a cell

With AxComboBox1
	.Columns.Add("Column 1")
	With .Items
		.AddItem(0)
		.CellHasCheckBox(.AddItem(1),0) = True
		.AddItem(2)
	End With
End With
30
How can I apply an strikeout font only a portion of the column's header

With AxComboBox1
	.Columns.Add("Column 1").HTMLCaption = "<s>Col</s>umn 1"
End With
27
How can I apply an italic font only a portion of the column's header

With AxComboBox1
	.Columns.Add("Column 1").HTMLCaption = "<i>Col</i>umn 1"
End With
353
How can I align the text/caption on the scroll bar

With AxComboBox1
	.set_ScrollPartCaption(EXCOMBOBOXLib.ScrollBarEnum.exHScroll,EXCOMBOBOXLib.ScrollPartEnum.exLowerBackPart,"left")
	.set_ScrollPartCaptionAlignment(EXCOMBOBOXLib.ScrollBarEnum.exHScroll,EXCOMBOBOXLib.ScrollPartEnum.exLowerBackPart,EXCOMBOBOXLib.AlignmentEnum.LeftAlignment)
	.set_ScrollPartCaption(EXCOMBOBOXLib.ScrollBarEnum.exHScroll,EXCOMBOBOXLib.ScrollPartEnum.exUpperBackPart,"right")
	.set_ScrollPartCaptionAlignment(EXCOMBOBOXLib.ScrollBarEnum.exHScroll,EXCOMBOBOXLib.ScrollPartEnum.exUpperBackPart,EXCOMBOBOXLib.AlignmentEnum.RightAlignment)
	.ColumnAutoResize = False
	.Columns.Add(1)
	.Columns.Add(2)
	.Columns.Add(3)
	.Columns.Add(4)
	.Columns.Add(5)
	.Columns.Add(6)
End With
183
How can I align the icon in the column's header in the center

With AxComboBox1
	.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
	With .Columns.Add("")
		.HeaderImage = 1
		.HeaderImageAlignment = EXCOMBOBOXLib.AlignmentEnum.CenterAlignment
	End With
End With
177
How can I align the column to the right, and its caption too

With AxComboBox1
	With .Columns.Add("Column")
		.Alignment = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
		.HeaderAlignment = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
	End With
	.Items.AddItem(0)
	.Items.AddItem(1)
End With
176
How can I align the column to the right

With AxComboBox1
	.Columns.Add("Column").Alignment = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
	.Items.AddItem(0)
	.Items.AddItem(1)
End With
304
How can I align the cell to the left, center or to the right

With AxComboBox1
	.TreeColumnIndex = -1
	.DrawGridLines = EXCOMBOBOXLib.GridLinesEnum.exRowLines
	.Columns.Add("Default")
	With .Items
		.CellHAlignment(.AddItem("left"),0) = EXCOMBOBOXLib.AlignmentEnum.LeftAlignment
		.CellHAlignment(.AddItem("center"),0) = EXCOMBOBOXLib.AlignmentEnum.CenterAlignment
		.CellHAlignment(.AddItem("right"),0) = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
	End With
End With
135
How can I add several columns to control's sort bar

With AxComboBox1
	.SortBarVisible = True
	.SortBarColumnWidth = 48
	.Columns.Add("C1").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortAscending
	.Columns.Add("C2").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortDescending
End With
313
How can I add separator - dividers items

Dim h
With AxComboBox1
	.MarkSearchColumn = False
	.TreeColumnIndex = -1
	.ScrollBySingleLine = False
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
		.CellSingleLine(h,1) = EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap
		h = .AddItem()
		.ItemDivider(h) = 0
		.ItemDividerLine(h) = EXCOMBOBOXLib.DividerLineEnum.DoubleDotLine
		.ItemDividerLineAlignment(h) = EXCOMBOBOXLib.DividerAlignmentEnum.DividerCenter
		.ItemHeight(h) = 6
		.SelectableItem(h) = False
		h = .AddItem("Cell 2")
		.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
		.CellSingleLine(h,1) = EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap
	End With
End With
226
How can I add or insert child items

Dim h
With AxComboBox1
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Cell 2"
		.CellCaption(.InsertItem(h,Nothing,"Cell 3"),1) = "Cell 4"
		.CellCaption(.InsertItem(h,Nothing,"Cell 5"),1) = "Cell 6"
		.ExpandItem(h) = True
	End With
End With
223
How can I add or insert an item

With AxComboBox1
	.Columns.Add("Default")
	.Items.AddItem("new item")
End With
224
How can I add or insert an item

Dim h
With AxComboBox1
	.Columns.Add("C1")
	.Columns.Add("C2")
	With .Items
		.CellCaption(.AddItem("Cell 1"),1) = "Cell 2"
		h = .AddItem("Cell 3")
		.CellCaption(h,1) = "Cell 4"
	End With
End With
225
How can I add or insert a child item

With AxComboBox1
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	.Columns.Add("Default")
	With .Items
		.InsertItem(.AddItem("root"),Nothing,"child")
	End With
End With
464
How can I add or change the padding (spaces) for captions in the control's header

With AxComboBox1
	.BeginUpdate()
	.Columns.Add("Padding-Left").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderPaddingLeft) = 18
	With .Columns.Add("Padding-Right")
		.Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderPaddingRight) = 18
		.HeaderAlignment = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
	End With
	.EndUpdate()
End With
3
How can I add multiple columns

With AxComboBox1
	With .Columns
		.Add("Column 1")
		.Add("Column 2")
	End With
End With
465
How can I add a vertical padding

With AxComboBox1
	.BeginUpdate()
	.DrawGridLines = EXCOMBOBOXLib.GridLinesEnum.exAllLines
	With .Columns.Add("Padding")
		.Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
		.Def(EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine) = False
		.Def(EXCOMBOBOXLib.DefColumnEnum.exCellPaddingLeft) = 6
		.Def(EXCOMBOBOXLib.DefColumnEnum.exCellPaddingRight) = 6
		.Def(EXCOMBOBOXLib.DefColumnEnum.exCellPaddingTop) = 6
		.Def(EXCOMBOBOXLib.DefColumnEnum.exCellPaddingBottom) = 6
	End With
	With .Items
		.AddItem("padding")
		.AddItem("padding")
	End With
	.EndUpdate()
End With
1
How can I add a new column

With AxComboBox1
	.Columns.Add("ColumnName")
End With
454
How can I add a horizontal scroll bar

With AxComboBox1
	.BeginUpdate()
	.ScrollBySingleLine = True
	.ColumnAutoResize = False
	.BackColorAlternate = RGB(240,240,240)
	With .Columns.Add("Default")
		.Width = 512
		.Def(EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine) = False
	End With
	With .Items
		.AddItem("Exontrol is devoted to create innovative user interface components for Windows applications, on COM or .NET platforms, since 19" & _
	"99. ""eXontrol"" comes from e(s)pecial (c)ontrol, where sc makes the X. We are a vendor not a reseller, and this is the single s" & _
	"ite where you can try or buy our products. If you are tired of looking for ""powerful"" components now it's time to show you rea" & _
	"l components. No registration required, no nag screens, no limitations, unlimited evaluation time.")
		.AddItem("A combo box is a commonly-used GUI tool. It is a combination of a drop-down list or list box and a single-line textbox, allowin" & _
	"g the user either to type a value directly into the control or choose from the list of existing options.")
	End With
	.EndUpdate()
End With
221
How can I access the properties of a column

With AxComboBox1
	.Columns.Add("A")
	.Columns.Item("A").HeaderBold = True
End With
595
Highlight the parent items

Dim h,hR
With AxComboBox1
	.BeginUpdate()
	.ConditionalFormats.Add("%CC0").ForeColor = RGB(255,0,0)
	.HeaderAppearance = EXCOMBOBOXLib.AppearanceEnum.Etched
	.HeaderHeight = 24
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	With .Columns
		.Add("Item").Width = 16
		.Add("Desc")
	End With
	With .Items
		hR = .AddItem("Root")
		.CellCaption(hR,1) = "The root directory /"
		h = .InsertItem(hR,Nothing,"Home")
		.CellCaption(h,1) = "The home directory with user directories Alice and Bob"
		.InsertItem(h,Nothing,"Alice")
		.InsertItem(h,Nothing,"Bob")
		.ExpandItem(h) = True
		h = .InsertItem(hR,Nothing,"Etc")
		.CellCaption(h,1) = "The etc directory with one configuration file"
		h = .InsertItem(h,Nothing,"nginx.conf")
		.CellCaption(.InsertItem(hR,Nothing,"Var"),1) = "The var directory"
		.ExpandItem(hR) = True
	End With
	.EndUpdate()
End With
596
Highlight the leaf items

Dim h,hR
With AxComboBox1
	.BeginUpdate()
	.ConditionalFormats.Add("%CC0=0").ForeColor = RGB(128,128,128)
	.HeaderAppearance = EXCOMBOBOXLib.AppearanceEnum.Etched
	.HeaderHeight = 24
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	With .Columns
		.Add("Item").Width = 16
		.Add("Desc")
	End With
	With .Items
		hR = .AddItem("Root")
		.CellCaption(hR,1) = "The root directory /"
		h = .InsertItem(hR,Nothing,"Home")
		.CellCaption(h,1) = "The home directory with user directories Alice and Bob"
		.InsertItem(h,Nothing,"Alice")
		.InsertItem(h,Nothing,"Bob")
		.ExpandItem(h) = True
		h = .InsertItem(hR,Nothing,"Etc")
		.CellCaption(h,1) = "The etc directory with one configuration file"
		h = .InsertItem(h,Nothing,"nginx.conf")
		.CellCaption(.InsertItem(hR,Nothing,"Var"),1) = "The var directory"
		.ExpandItem(hR) = True
	End With
	.EndUpdate()
End With
594
Highlight the item being expanded or collapsed

Dim h,hR
With AxComboBox1
	.BeginUpdate()
	.ConditionalFormats.Add("%CX0").Bold = True
	.HeaderAppearance = EXCOMBOBOXLib.AppearanceEnum.Etched
	.HeaderHeight = 24
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	With .Columns
		.Add("Item").Width = 16
		.Add("Desc")
	End With
	With .Items
		hR = .AddItem("Root")
		.CellCaption(hR,1) = "The root directory /"
		h = .InsertItem(hR,Nothing,"Home")
		.CellCaption(h,1) = "The home directory with user directories Alice and Bob"
		.InsertItem(h,Nothing,"Alice")
		.InsertItem(h,Nothing,"Bob")
		.ExpandItem(h) = True
		h = .InsertItem(hR,Nothing,"Etc")
		.CellCaption(h,1) = "The etc directory with one configuration file"
		h = .InsertItem(h,Nothing,"nginx.conf")
		.CellCaption(.InsertItem(hR,Nothing,"Var"),1) = "The var directory"
		.ExpandItem(hR) = True
	End With
	.EndUpdate()
End With
589
Force hover-all feature
With AxComboBox1
	.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exScrollHoverAll,-1)
End With
515
FilterBarCaption Predefined Keywords

' AfterExpandItem event - Fired after an item is expanded (collapsed).
Private Sub AxComboBox1_AfterExpandItem(ByVal sender As System.Object, ByVal e As AxEXCOMBOBOXLib._IComboBoxEvents_AfterExpandItemEvent) Handles AxComboBox1.AfterExpandItem
	With AxComboBox1
		.Refresh()
	End With
End Sub

Dim h
With AxComboBox1
	.BeginUpdate()
	.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
	.Columns.Add("Item").DisplayFilterButton = True
	With .Columns.Add("Check")
		.Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
		.DisplayFilterButton = True
		.DisplayFilterPattern = False
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exCheck
	End With
	With .Columns.Add("Pos")
		.AllowSizing = False
		.AllowSort = False
		.Width = 32
		.FormatColumn = "1 apos ``"
		.Position = 0
	End With
	With .Items
		.AddItem("Item A")
		h = .AddItem("Item B")
		.CellState(.InsertItem(h,Nothing,"Sub-Item B1"),1) = 1
		.InsertItem(h,Nothing,"Sub-Item B2")
		.ExpandItem(h) = True
		.AddItem("Item C")
	End With
	.FilterInclude = EXCOMBOBOXLib.FilterIncludeEnum.exItemsWithChilds
	.FilterBarFont = .Font
	.FilterBarCaption = "`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</" & _
	"i></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>" & _
	": ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF>" & _
	"<i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</" & _
	"i></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=8" & _
	"08080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount +" & _
	" `</fgcolor>`"
	.FilterBarPromptPattern = "B"
	.FilterBarPromptVisible = EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCaptionVisible Or EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarVisible Or EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible
	With .Columns.Item(0)
		.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exFilter
		.Filter = "Item A|Item B"
	End With
	.ApplyFilter()
	.EndUpdate()
End With